MerchandiseHierarchyDimension

Entity Definition

Logical Name : MerchandiseHierarchyDimension
Physical Name : ETL_DW3_DIM_MDSE_HIER

A dimensional table that defines merchandise classifications that are used to group and categorize items based on common characteristics. An item may be associated with one or more different merchandise hierarchies. This table is used to enable summarization and drill down analysis based on item categories.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MerchandiseHierarchyFunctionID (PK) A unique system assigned identifier for the MerchandiseHierarchyFunction id_mrhrc_fnc Identity int
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) ItemDimension(ETL_DW3_DIM_ITM)
MerchandiseHierarchyFunctionName The name of MerchandiseHierarchyFunction NM_MRHRC_FNC DescriptionShort varchar(255)
ParentMerchandiseHierarchyLevelID A unique system assigned identifier for the Level within the merchandise hierarchy tree. id_mrhrc_lv_prnt Identity int
ChildMerchandiseHierarchyGroupID Unique system assigned identifier for a group or class of merchandise. id_mrhrc_gp_chld Identity int
ParentMerchandiseHierarchyGroupID Unique system assigned identifier for a group or class of merchandise. id_mrhrc_gp_prnt Identity int
MerchaniseHierarchyIDTreePath A pipe delimited, bottom up (left to right) list of merchandise hierarchy level ID's ina merchandise hierarchy. MRCHRC_ID_TREE_PTH String varchar(4000)
MerchandiseHierarchyLevelPath A pipe delimited, bottom up (left to right) list of merchandise hierarchy level numbers in a merchandise hierarchy MRHRC_LVL_PTH String varchar(4000)
MerchandiseHierarchyLevelNamePath A pipe delimited, bottom up (left to right) list of merchandise hierarchy level NAMES (metadata description/name of levels in a hierarchy) for a merchandise hierarchy. MRHRC_LV_NM_PTH String varchar(4000)
MerchandiseHierarchyGroupNamePath A pipe delimited, bottom up (left to right) list of merchandise hierarchy level group NAMES for a merchandise hierarchy. MRHRC_LVL_GP_NM_PTH String varchar(4000)
MerchandiseHierarchyRootCode A derived attribute that indicates that you are at the ROOT for agiven merchandise hierarchy. CD_MRHRC_ROOT String varchar(4)
ItemName A combination of ItemID and ItemName for display purposes. This is a derived attribute (created in an ETL view). ITM_ID_NM String varchar(75)

Relationships

Parent Entity Verb Phrase Child Entity
ItemDimension is hierarchically classified through MerchandiseHierarchyDimension

No Logical Views for MerchandiseHierarchyDimension